USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[MapsSelectMapByName]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.MapsSelectMapByName
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 08/29/08
-- Description:	Maps Select By Name
-- =============================================
CREATE PROCEDURE MapsSelectMapByName

            
            @MapShortName varchar(30)
	

AS
BEGIN

SELECT [MapId], [MapShortName], [MapFullName], [MapTypeId], 	[MapImageUrl],
		[MinX],
		[MinY],
		[MaxX],
		[MaxY],
		[ResX],
		[ResY],
		[FlipX],
		[FlipY]
	
FROM [Maps]
WHERE [MapShortName] = @MapShortName

END
GO
